﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using dhDataAcess.orderLinqDAL;

namespace dhDataAcess.orderDAL
{
   public class custAddListDAL
    {
       string tableName = "custAddList";
       private SqlTransaction tran = null;
       private SqlConnection conn = null;
       public custAddListDAL(SqlConnection _conn,SqlTransaction _transaction)
        {
            tran = _transaction;
            conn=_conn;
        }
        /// <summary>
        /// 插入客户送货地址信息表数据
        /// </summary>
        /// <param name="deptRow"></param>
        /// <returns></returns>
       public int custAddListInsert(custAddListModel row)
       {
           SqlCommand cmd = new SqlCommand();
           cmd.Connection = conn;
           cmd.CommandType = CommandType.Text;
           string insertstr = baseBLL.dTableColumnRead.insertSqlStr(tableName).ToString();
           SqlParameter[] para = {
                               new SqlParameter ("@mark",row.mark ),
                               new SqlParameter ("@updateUser",row .updateUser),
                               new SqlParameter ("@updateDate",row .updateDate),
                               new SqlParameter ("@createUser",row .createUser),
                               new SqlParameter ("@createDate",row .createDate),
                               new SqlParameter ("@linkMan",row.linkMan  ),
                               new SqlParameter ("@phone",row .phone ),
                               new SqlParameter ("@addres",row .addres  ),
                               new SqlParameter ("@custNum",row .custNum  )
                                 };
           cmd.Parameters.AddRange(para);
           cmd.CommandText = insertstr;
           cmd.Transaction = tran;
           int i = cmd.ExecuteNonQuery();
           return i;
       }
       /// <summary>
       /// 更新一行客户送货地址信息表数据 
       /// </summary>
       /// <param name="deptRow"></param>
       /// <returns></returns>
       public int custAddListUpdate(custAddListModel row)
       {
           SqlCommand cmd = new SqlCommand();
           cmd.Connection = conn;
           cmd.CommandType = CommandType.Text;
           string updatestr = baseBLL.dTableColumnRead.updateSqlStr(tableName).ToString();
           SqlParameter[] para = {
                                   new SqlParameter ("@recordid",row.recordid  ),
                                   new SqlParameter ("@mark",row.mark ),
                                   new SqlParameter ("@updateUser",row .updateUser),
                                   new SqlParameter ("@updateDate",row .updateDate),
                                   new SqlParameter ("@createUser",row .createUser),
                                   new SqlParameter ("@createDate",row .createDate),
                                   new SqlParameter ("@linkMan",row.linkMan  ),
                                   new SqlParameter ("@phone",row .phone ),
                                   new SqlParameter ("@addres",row .addres  ),
                                   new SqlParameter ("@custNum",row .custNum  )
                                 };
           cmd.Parameters.AddRange(para);
           cmd.CommandText = updatestr;
           cmd.Transaction = tran;
           int i = cmd.ExecuteNonQuery();
           return i;

       }
        /// <summary>
       /// 删除一行客户送货地址信息表数据
        /// </summary>
        /// <param name="groupNum"></param>
        /// <returns></returns>
       public int custAddListDel(string recordid)
       {
           SqlCommand cmd = new SqlCommand();
           cmd.Connection = conn;
           cmd.CommandType = CommandType.Text;
           string deletestr = baseBLL.dTableColumnRead.delSqlStr(tableName).ToString();
           //string deletestr = "delete custList where custNum=@custNum";
           SqlParameter[] para = {
                               
                               new SqlParameter ("@recordid",recordid )
                                 };
           cmd.Parameters.AddRange(para);
           cmd.CommandText = deletestr;
           cmd.Transaction = tran;
           int i = cmd.ExecuteNonQuery();
           return i;
       }
    }
}
